﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetSucursalByUbigeo')
	BEGIN
		DROP  Procedure  GetSucursalByUbigeo
	END

GO

CREATE Procedure GetSucursalByUbigeo

	(
		@idUbigeo int
	)

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[Direccion],
	[EsPrincipal],
	[IdSucursal],
	[IdUbigeo],
	[Telefono]
	FROM [Sucursal] 
	WHERE [IdUbigeo] = @idUbigeo

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetSucursalByUbigeo TO PUBLIC

GO


